352327 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20021} Types : [INTEGER, INTEGER, INTEGER]
352329 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20021} executed. 8.8706 millis. select
            id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         where  user_id = ?
        
        
        
        
        
        
        
        
        
        
        
        
        
                and status = ?
        
        
                and is_checked = ? 
        order by publish_time desc
352329 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20021, rs-50613} open
352330 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20021, rs-50613} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
352330 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20021, rs-50613} Result: [35, 1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 6, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -]
352331 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20021, rs-50613} closed
352331 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20021} clearParameters. 
352331 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20004} closed
352331 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-recycle
352331 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-connect
352332 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022} created. select * from material
        left join favorite on favorite.material_id = material.id
        where favorite.user_id = ? and material.status = 1 and material.is_checked = 1
        order by favorite.id desc
352332 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022} Parameters : [1]
352332 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022} Types : [INTEGER]
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022} executed. 0.6952 millis. select * from material
        left join favorite on favorite.material_id = material.id
        where favorite.user_id = ? and material.status = 1 and material.is_checked = 1
        order by favorite.id desc
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022, rs-50614} open
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022, rs-50614} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info, id, user_id, material_id]
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022, rs-50614} closed
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20022} clearParameters. 
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20005} closed
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-recycle
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-connect
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007} Parameters : [1]
352333 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007} Types : [INTEGER]
352334 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007} executed. 0.5587 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
352334 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007, rs-50615} open
352334 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007, rs-50615} Header: [id, open_id, name, sex, img, info, status, role, register_time]
352334 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007, rs-50615} Result: [1, 1111, 管理员, 1, https://s1.ax1x.com/2020/08/30/dqJ6wd.jpg, 一只小张三, 1, 1, 2020-11-02 20:50:28.0]
352334 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007, rs-50615} closed
352334 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20007} clearParameters. 
352334 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-recycle
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-connect
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008} Parameters : [1]
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008} Types : [INTEGER]
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008} executed. 0.5211 millis. select
          id, name, count  
        from kind
         WHERE id = ?
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008, rs-50616} open
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008, rs-50616} Header: [id, name, count]
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008, rs-50616} Result: [1, 图片, 3]
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008, rs-50616} closed
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20008} clearParameters. 
352335 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-recycle
352336 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-connect
352336 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009} Parameters : [35]
352336 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009} Types : [INTEGER]
352337 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009} executed. 1.1054 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
352337 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009, rs-50617} open
352337 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009, rs-50617} Header: [ROUND(avg(stars))]
352337 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009, rs-50617} Result: [null]
352337 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009, rs-50617} closed
352338 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20009} clearParameters. 
352338 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-recycle
352338 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-connect
352338 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20010} Parameters : [35]
352338 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20010} Types : [INTEGER]
352339 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20010} executed. 0.6246 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
352339 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20010, rs-50618} open
352339 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20010, rs-50618} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
352339 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20010, rs-50618} closed
352339 DEBUG [2020-11-30 18:05:09]  {conn-10005, pstmt-20010} clearParameters. 
352339 DEBUG [2020-11-30 18:05:09]  {conn-10005} pool-recycle
357973 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357974 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000} Parameters : []
357974 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000} Types : []
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000} executed. 0.7415 millis. select
            id, name, count  
        from kind
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} open
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} Header: [id, name, count]
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} Result: [1, 图片, 3]
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} Result: [3, 音频, 2]
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} Result: [4, 字体, 3]
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} Result: [5, WorldPress主题, 1]
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} Result: [6, 前端页面, 3]
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} Result: [13, PPT模板, 4]
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000, rs-50619} closed
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20000} clearParameters. 
357975 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357976 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357976 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001} Parameters : []
357976 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001} Types : []
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001} executed. 0.7489 millis. select
            id, name, target_url, type  
        from link
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001, rs-50620} open
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001, rs-50620} Header: [id, name, target_url, type]
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001, rs-50620} Result: [5, 百度, http://www.baidu.com, 2]
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001, rs-50620} Result: [6, 字体素材, http://127.0.0.1:8082/su-share/materials?kId=4, 1]
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001, rs-50620} Result: [7, WordPress精选主题, http://127.0.0.1:8082/su-share/materials?kId=5, 1]
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001, rs-50620} closed
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20001} clearParameters. 
357977 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357978 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357979 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016} Parameters : [1]
357979 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016} Types : [INTEGER]
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016} executed. 1.0926 millis. SELECT count(0) FROM material LEFT JOIN favorite ON favorite.material_id = material.id WHERE favorite.user_id = ? AND material.status = 1 AND material.is_checked = 1
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016, rs-50621} open
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016, rs-50621} Header: [count(0)]
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016, rs-50621} Result: [0]
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016, rs-50621} closed
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20016} clearParameters. 
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20017} Parameters : [1, 5]
357980 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20017} Types : [INTEGER, INTEGER]
357981 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20017} executed. 0.6471 millis. select * from material
        left join favorite on favorite.material_id = material.id
        where favorite.user_id = ? and material.status = 1 and material.is_checked = 1
        order by favorite.id desc LIMIT ? 
357981 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20017, rs-50622} open
357981 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20017, rs-50622} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info, id, user_id, material_id]
357981 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20017, rs-50622} closed
357981 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20017} clearParameters. 
357981 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357981 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357982 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20018} Parameters : [1, 0]
357982 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20018} Types : [INTEGER, INTEGER]
357982 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20018} executed. 0.6703 millis. select
            id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         where  status = ?
        
        
                and is_checked = ? 
        order by publish_time desc
357982 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20018, rs-50623} open
357982 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20018, rs-50623} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
357983 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20018, rs-50623} closed
357983 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20018} clearParameters. 
357983 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357983 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357983 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20019} Parameters : [1, 0]
357983 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20019} Types : [INTEGER, INTEGER]
357984 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20019} executed. 0.6242 millis. select
            id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time  
        from message
         where  receive_user_id = ?
        
        
        
        
        
        
                and is_read = ?
357984 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20019, rs-50624} open
357984 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20019, rs-50624} Header: [id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time]
357984 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20019, rs-50624} closed
357984 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20019} clearParameters. 
357984 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357984 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023} created. select
          id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         WHERE id = ?
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023} Parameters : [35]
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023} Types : [INTEGER]
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023} executed. 0.7661 millis. select
          id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         WHERE id = ?
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023, rs-50625} open
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023, rs-50625} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023, rs-50625} Result: [35, 1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 6, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -]
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023, rs-50625} closed
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20023} clearParameters. 
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20006} closed
357985 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357986 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357986 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20024} created. update material
         SET user_id = ?,
        
        
                name = ?,
        
        
                kind_id = ?,
        
        
                info = ?,
        
        
                img = ?,
        
        
                imgs = ?,
        
        
                read_count = ?,
        
        
                download_count = ?,
        
        
                publish_time = ?,
        
        
                file_path = ?,
        
        
                extension = ?,
        
        
                size = ?,
        
        
                status = ?,
        
        
                is_checked = ?,
        
        
                checked_info = ? 
         WHERE id = ?
357987 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20024} Parameters : [1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 7, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -, 35]
357987 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20024} Types : [INTEGER, VARCHAR, INTEGER, VARCHAR, VARCHAR, VARCHAR, INTEGER, INTEGER, TIMESTAMP, VARCHAR, VARCHAR, VARCHAR, INTEGER, INTEGER, VARCHAR, INTEGER]
357990 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20024} executed. 2.8393 millis. update material
         SET user_id = ?,
        
        
                name = ?,
        
        
                kind_id = ?,
        
        
                info = ?,
        
        
                img = ?,
        
        
                imgs = ?,
        
        
                read_count = ?,
        
        
                download_count = ?,
        
        
                publish_time = ?,
        
        
                file_path = ?,
        
        
                extension = ?,
        
        
                size = ?,
        
        
                status = ?,
        
        
                is_checked = ?,
        
        
                checked_info = ? 
         WHERE id = ?
357990 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20024} clearParameters. 
357990 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20011} closed
357990 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357992 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357992 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025} created. SELECT count(0) FROM material WHERE kind_id = ? AND status = 1 AND is_checked = 1 AND id != ?
357992 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025} Parameters : [1, 35]
357992 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025} Types : [INTEGER, INTEGER]
357993 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025} executed. 1.1643 millis. SELECT count(0) FROM material WHERE kind_id = ? AND status = 1 AND is_checked = 1 AND id != ?
357993 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025, rs-50626} open
357993 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025, rs-50626} Header: [count(0)]
357994 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025, rs-50626} Result: [2]
357994 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025, rs-50626} closed
357994 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20025} clearParameters. 
357994 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20012} closed
357994 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026} created. select
          id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
        where kind_id = ? and status = 1 and is_checked = 1 and id != ?
        order by download_count desc LIMIT ? 
357995 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026} Parameters : [1, 35, 3]
357995 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026} Types : [INTEGER, INTEGER, INTEGER]
357995 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026} executed. 0.7893 millis. select
          id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
        where kind_id = ? and status = 1 and is_checked = 1 and id != ?
        order by download_count desc LIMIT ? 
357995 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026, rs-50627} open
357996 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026, rs-50627} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
357996 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026, rs-50627} Result: [17, 2, 城市俯视鸟瞰背景图片, 1, 城市俯视鸟瞰PPT背景图片。一组城市俯瞰图片，jpg格式高清大图，大气磅礴，适合商务类PPT背景图片使用。, https://gitee.com/cn_moti/su-share/raw/master/2/72d8adf428c04734bf3ab4716f28fa02.jpg, ["https://gitee.com/cn_moti/su-share/raw/master/2/6c62b29b0a9c4c6f9ea203efe275ab92.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/e8ce1e01fe5f4366aad7a585d4f18f4f.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/7a89ddf9fc484b159ce7bd0f5624cdc2.jpg"], 2, 0, 2020-11-29 18:56:08.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/8f695c0ef4aa4ff18ccf09a214e4b4a2.zip, .zip, 188B, 1, 1, -]
357996 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026, rs-50627} Result: [18, 2, 26张高清沙漠背景图片, 1, 高清沙漠PPT背景图片，共26张，JPG格式，高清大图，漂亮的沙漠风景幻灯片背景图片。 , https://gitee.com/cn_moti/su-share/raw/master/2/a002baff05494e408799962e095b5717.jpg, ["https://gitee.com/cn_moti/su-share/raw/master/2/3470504d63984b0aae5dcb78636b705d.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/119c2a45c200454cb72e4fa160ae7c6f.jpg"], 2, 0, 2020-11-29 18:57:15.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/bbe08735bbc34b5a9eaf5e9890206ff7.zip, .zip, 188B, 1, 1, -]
357996 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026, rs-50627} closed
357997 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20026} clearParameters. 
357997 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20002} closed
357997 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357997 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357997 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} Parameters : [1]
357997 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} Types : [INTEGER]
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} executed. 0.6371 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50628} open
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50628} Header: [id, open_id, name, sex, img, info, status, role, register_time]
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50628} Result: [1, 1111, 管理员, 1, https://s1.ax1x.com/2020/08/30/dqJ6wd.jpg, 一只小张三, 1, 1, 2020-11-02 20:50:28.0]
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50628} closed
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} clearParameters. 
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
357998 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
357999 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} Parameters : [1]
357999 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} Types : [INTEGER]
357999 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} executed. 0.6246 millis. select
          id, name, count  
        from kind
         WHERE id = ?
357999 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50629} open
357999 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50629} Header: [id, name, count]
357999 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50629} Result: [1, 图片, 3]
357999 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50629} closed
358000 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} clearParameters. 
358000 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358000 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358000 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} Parameters : [35]
358000 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} Types : [INTEGER]
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} executed. 0.6916 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50630} open
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50630} Header: [ROUND(avg(stars))]
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50630} Result: [null]
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50630} closed
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} clearParameters. 
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358001 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358002 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} Parameters : [35]
358002 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} Types : [INTEGER]
358002 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} executed. 0.6615 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
358002 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50631} open
358002 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50631} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
358003 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50631} closed
358003 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} clearParameters. 
358003 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358003 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358004 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027} created. select
            id, user_id, material_id  
        from favorite
         where  user_id = ?
        
        
                and material_id = ?
358004 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027} Parameters : [1, 35]
358004 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027} Types : [INTEGER, INTEGER]
358006 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027} executed. 2.0511 millis. select
            id, user_id, material_id  
        from favorite
         where  user_id = ?
        
        
                and material_id = ?
358006 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027, rs-50632} open
358007 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027, rs-50632} Header: [id, user_id, material_id]
358007 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027, rs-50632} closed
358007 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20027} clearParameters. 
358007 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20013} closed
358007 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358007 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358008 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028} created. select   id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
        where material_id = ? and reply_id = 0 order by comment_time desc
358008 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028} Parameters : [35]
358008 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028} Types : [INTEGER]
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028} executed. 0.8303 millis. select   id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
        where material_id = ? and reply_id = 0 order by comment_time desc
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028, rs-50633} open
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028, rs-50633} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028, rs-50633} closed
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20028} clearParameters. 
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20014} closed
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358009 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358010 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} Parameters : [2]
358010 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} Types : [INTEGER]
358010 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} executed. 0.6569 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
358010 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50634} open
358010 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50634} Header: [id, open_id, name, sex, img, info, status, role, register_time]
358010 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50634} Result: [2, 2222, 杰瑞, 0, https://s1.ax1x.com/2020/08/30/dqJhSf.jpg, 一只小耗子, 1, 0, 2020-11-18 15:56:06.0]
358011 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50634} closed
358011 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} clearParameters. 
358011 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358011 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358011 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} Parameters : [1]
358011 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} Types : [INTEGER]
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} executed. 0.6096 millis. select
          id, name, count  
        from kind
         WHERE id = ?
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50635} open
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50635} Header: [id, name, count]
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50635} Result: [1, 图片, 3]
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50635} closed
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} clearParameters. 
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358012 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358013 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} Parameters : [17]
358013 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} Types : [INTEGER]
358013 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} executed. 0.6474 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
358013 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50636} open
358013 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50636} Header: [ROUND(avg(stars))]
358013 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50636} Result: [5]
358014 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50636} closed
358014 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} clearParameters. 
358014 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358014 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358014 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} Parameters : [17]
358014 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} Types : [INTEGER]
358015 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} executed. 0.7475 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
358015 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50637} open
358015 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50637} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
358015 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50637} Result: [10, 2, 17, @@@@, 5, 0, 2020-11-29 19:02:18.0, 0]
358015 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50637} closed
358015 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} clearParameters. 
358016 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358016 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358016 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} Parameters : [2]
358016 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} Types : [INTEGER]
358017 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} executed. 0.7224 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
358017 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50638} open
358017 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50638} Header: [id, open_id, name, sex, img, info, status, role, register_time]
358017 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50638} Result: [2, 2222, 杰瑞, 0, https://s1.ax1x.com/2020/08/30/dqJhSf.jpg, 一只小耗子, 1, 0, 2020-11-18 15:56:06.0]
358017 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007, rs-50638} closed
358017 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20007} clearParameters. 
358017 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358018 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358018 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} Parameters : [1]
358018 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} Types : [INTEGER]
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} executed. 0.6162 millis. select
          id, name, count  
        from kind
         WHERE id = ?
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50639} open
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50639} Header: [id, name, count]
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50639} Result: [1, 图片, 3]
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008, rs-50639} closed
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20008} clearParameters. 
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} Parameters : [18]
358019 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} Types : [INTEGER]
358020 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} executed. 0.7352 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
358020 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50640} open
358020 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50640} Header: [ROUND(avg(stars))]
358020 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50640} Result: [5]
358020 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009, rs-50640} closed
358021 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20009} clearParameters. 
358021 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
358021 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-connect
358021 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} Parameters : [18]
358021 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} Types : [INTEGER]
358022 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} executed. 0.7904 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
358022 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50641} open
358022 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50641} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
358023 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50641} Result: [4, 2, 18, Nice, 5, 0, 2020-11-29 19:01:13.0, 0]
358024 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010, rs-50641} closed
358024 DEBUG [2020-11-30 18:05:14]  {conn-10005, pstmt-20010} clearParameters. 
358024 DEBUG [2020-11-30 18:05:14]  {conn-10005} pool-recycle
360397 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-connect
360397 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000} Parameters : []
360397 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000} Types : []
360398 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000} executed. 1.2211 millis. select
            id, name, count  
        from kind
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} open
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} Header: [id, name, count]
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} Result: [1, 图片, 3]
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} Result: [3, 音频, 2]
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} Result: [4, 字体, 3]
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} Result: [5, WorldPress主题, 1]
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} Result: [6, 前端页面, 3]
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} Result: [13, PPT模板, 4]
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000, rs-50642} closed
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20000} clearParameters. 
360399 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-recycle
360400 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-connect
360400 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001} Parameters : []
360400 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001} Types : []
360400 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001} executed. 0.6637 millis. select
            id, name, target_url, type  
        from link
360400 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001, rs-50643} open
360400 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001, rs-50643} Header: [id, name, target_url, type]
360401 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001, rs-50643} Result: [5, 百度, http://www.baidu.com, 2]
360401 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001, rs-50643} Result: [6, 字体素材, http://127.0.0.1:8082/su-share/materials?kId=4, 1]
360401 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001, rs-50643} Result: [7, WordPress精选主题, http://127.0.0.1:8082/su-share/materials?kId=5, 1]
360401 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001, rs-50643} closed
360401 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20001} clearParameters. 
360401 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-recycle
360402 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-connect
360403 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016} Parameters : [1]
360403 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016} Types : [INTEGER]
360405 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016} executed. 2.2504 millis. SELECT count(0) FROM material LEFT JOIN favorite ON favorite.material_id = material.id WHERE favorite.user_id = ? AND material.status = 1 AND material.is_checked = 1
360405 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016, rs-50644} open
360405 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016, rs-50644} Header: [count(0)]
360405 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016, rs-50644} Result: [0]
360406 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016, rs-50644} closed
360407 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20016} clearParameters. 
360407 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20017} Parameters : [1, 5]
360407 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20017} Types : [INTEGER, INTEGER]
360408 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20017} executed. 0.8715 millis. select * from material
        left join favorite on favorite.material_id = material.id
        where favorite.user_id = ? and material.status = 1 and material.is_checked = 1
        order by favorite.id desc LIMIT ? 
360408 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20017, rs-50645} open
360408 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20017, rs-50645} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info, id, user_id, material_id]
360408 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20017, rs-50645} closed
360408 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20017} clearParameters. 
360408 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-recycle
360409 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-connect
360409 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20018} Parameters : [1, 0]
360409 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20018} Types : [INTEGER, INTEGER]
360410 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20018} executed. 0.7091 millis. select
            id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         where  status = ?
        
        
                and is_checked = ? 
        order by publish_time desc
360410 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20018, rs-50646} open
360410 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20018, rs-50646} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
360410 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20018, rs-50646} closed
360410 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20018} clearParameters. 
360410 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-recycle
360410 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-connect
360411 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20019} Parameters : [1, 0]
360411 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20019} Types : [INTEGER, INTEGER]
360411 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20019} executed. 0.641 millis. select
            id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time  
        from message
         where  receive_user_id = ?
        
        
        
        
        
        
                and is_read = ?
360411 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20019, rs-50647} open
360411 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20019, rs-50647} Header: [id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time]
360411 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20019, rs-50647} closed
360411 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20019} clearParameters. 
360412 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-recycle
360413 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-connect
360413 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20027} Parameters : [1, 35]
360413 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20027} Types : [INTEGER, INTEGER]
360414 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20027} executed. 0.8332 millis. select
            id, user_id, material_id  
        from favorite
         where  user_id = ?
        
        
                and material_id = ?
360414 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20027, rs-50648} open
360414 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20027, rs-50648} Header: [id, user_id, material_id]
360414 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20027, rs-50648} closed
360414 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20027} clearParameters. 
360414 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-recycle
360415 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-connect
360693 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029} created. insert into favorite
         ( user_id,
        
        
                material_id ) 
         values ( ?,
        
        
                ? )
360693 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029} Parameters : [1, 35]
360693 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029} Types : [INTEGER, INTEGER]
360699 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029} executed. 6.3572 millis. insert into favorite
         ( user_id,
        
        
                material_id ) 
         values ( ?,
        
        
                ? )
360700 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029, rs-50649} open
360700 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029, rs-50649} Header: [GENERATED_KEY]
360702 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029, rs-50649} Result: [23]
360702 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029, rs-50649} closed
360702 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20029} clearParameters. 
360703 DEBUG [2020-11-30 18:05:17]  {conn-10005, pstmt-20015} closed
360703 DEBUG [2020-11-30 18:05:17]  {conn-10005} pool-recycle
361794 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361796 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000} Parameters : []
361796 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000} Types : []
361798 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000} executed. 2.2758 millis. select
            id, name, count  
        from kind
361798 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} open
361799 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} Header: [id, name, count]
361799 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} Result: [1, 图片, 3]
361799 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} Result: [3, 音频, 2]
361799 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} Result: [4, 字体, 3]
361800 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} Result: [5, WorldPress主题, 1]
361800 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} Result: [6, 前端页面, 3]
361800 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} Result: [13, PPT模板, 4]
361801 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000, rs-50650} closed
361802 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20000} clearParameters. 
361803 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361803 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361804 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001} Parameters : []
361804 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001} Types : []
361805 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001} executed. 1.1728 millis. select
            id, name, target_url, type  
        from link
361805 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001, rs-50651} open
361805 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001, rs-50651} Header: [id, name, target_url, type]
361805 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001, rs-50651} Result: [5, 百度, http://www.baidu.com, 2]
361806 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001, rs-50651} Result: [6, 字体素材, http://127.0.0.1:8082/su-share/materials?kId=4, 1]
361806 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001, rs-50651} Result: [7, WordPress精选主题, http://127.0.0.1:8082/su-share/materials?kId=5, 1]
361806 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001, rs-50651} closed
361807 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20001} clearParameters. 
361807 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361812 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361812 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016} Parameters : [1]
361812 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016} Types : [INTEGER]
361816 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016} executed. 4.1031 millis. SELECT count(0) FROM material LEFT JOIN favorite ON favorite.material_id = material.id WHERE favorite.user_id = ? AND material.status = 1 AND material.is_checked = 1
361816 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016, rs-50652} open
361816 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016, rs-50652} Header: [count(0)]
361816 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016, rs-50652} Result: [1]
361817 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016, rs-50652} closed
361817 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20016} clearParameters. 
361817 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017} Parameters : [1, 5]
361817 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017} Types : [INTEGER, INTEGER]
361819 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017} executed. 1.8085 millis. select * from material
        left join favorite on favorite.material_id = material.id
        where favorite.user_id = ? and material.status = 1 and material.is_checked = 1
        order by favorite.id desc LIMIT ? 
361819 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017, rs-50653} open
361819 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017, rs-50653} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info, id, user_id, material_id]
361820 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017, rs-50653} Result: [35, 1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 7, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -, 23, 1, 35]
361821 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017, rs-50653} closed
361821 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20017} clearParameters. 
361821 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361822 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361822 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20018} Parameters : [1, 0]
361822 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20018} Types : [INTEGER, INTEGER]
361823 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20018} executed. 0.9225 millis. select
            id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         where  status = ?
        
        
                and is_checked = ? 
        order by publish_time desc
361823 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20018, rs-50654} open
361823 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20018, rs-50654} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
361823 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20018, rs-50654} closed
361823 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20018} clearParameters. 
361823 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361824 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361824 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20019} Parameters : [1, 0]
361824 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20019} Types : [INTEGER, INTEGER]
361825 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20019} executed. 0.7574 millis. select
            id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time  
        from message
         where  receive_user_id = ?
        
        
        
        
        
        
                and is_read = ?
361825 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20019, rs-50655} open
361825 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20019, rs-50655} Header: [id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time]
361825 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20019, rs-50655} closed
361825 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20019} clearParameters. 
361825 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361825 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361826 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023} Parameters : [35]
361826 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023} Types : [INTEGER]
361826 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023} executed. 0.9675 millis. select
          id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         WHERE id = ?
361827 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023, rs-50656} open
361827 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023, rs-50656} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
361827 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023, rs-50656} Result: [35, 1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 7, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -]
361827 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023, rs-50656} closed
361827 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20023} clearParameters. 
361827 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361828 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361828 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20024} Parameters : [1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 8, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -, 35]
361828 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20024} Types : [INTEGER, VARCHAR, INTEGER, VARCHAR, VARCHAR, VARCHAR, INTEGER, INTEGER, TIMESTAMP, VARCHAR, VARCHAR, VARCHAR, INTEGER, INTEGER, VARCHAR, INTEGER]
361832 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20024} executed. 3.3477 millis. update material
         SET user_id = ?,
        
        
                name = ?,
        
        
                kind_id = ?,
        
        
                info = ?,
        
        
                img = ?,
        
        
                imgs = ?,
        
        
                read_count = ?,
        
        
                download_count = ?,
        
        
                publish_time = ?,
        
        
                file_path = ?,
        
        
                extension = ?,
        
        
                size = ?,
        
        
                status = ?,
        
        
                is_checked = ?,
        
        
                checked_info = ? 
         WHERE id = ?
361832 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20024} clearParameters. 
361832 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361833 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361834 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025} Parameters : [1, 35]
361834 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025} Types : [INTEGER, INTEGER]
361835 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025} executed. 1.2358 millis. SELECT count(0) FROM material WHERE kind_id = ? AND status = 1 AND is_checked = 1 AND id != ?
361835 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025, rs-50657} open
361835 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025, rs-50657} Header: [count(0)]
361835 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025, rs-50657} Result: [2]
361835 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025, rs-50657} closed
361835 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20025} clearParameters. 
361836 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026} Parameters : [1, 35, 3]
361836 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026} Types : [INTEGER, INTEGER, INTEGER]
361837 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026} executed. 1.2268 millis. select
          id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
        where kind_id = ? and status = 1 and is_checked = 1 and id != ?
        order by download_count desc LIMIT ? 
361838 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026, rs-50658} open
361838 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026, rs-50658} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
361838 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026, rs-50658} Result: [17, 2, 城市俯视鸟瞰背景图片, 1, 城市俯视鸟瞰PPT背景图片。一组城市俯瞰图片，jpg格式高清大图，大气磅礴，适合商务类PPT背景图片使用。, https://gitee.com/cn_moti/su-share/raw/master/2/72d8adf428c04734bf3ab4716f28fa02.jpg, ["https://gitee.com/cn_moti/su-share/raw/master/2/6c62b29b0a9c4c6f9ea203efe275ab92.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/e8ce1e01fe5f4366aad7a585d4f18f4f.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/7a89ddf9fc484b159ce7bd0f5624cdc2.jpg"], 2, 0, 2020-11-29 18:56:08.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/8f695c0ef4aa4ff18ccf09a214e4b4a2.zip, .zip, 188B, 1, 1, -]
361840 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026, rs-50658} Result: [18, 2, 26张高清沙漠背景图片, 1, 高清沙漠PPT背景图片，共26张，JPG格式，高清大图，漂亮的沙漠风景幻灯片背景图片。 , https://gitee.com/cn_moti/su-share/raw/master/2/a002baff05494e408799962e095b5717.jpg, ["https://gitee.com/cn_moti/su-share/raw/master/2/3470504d63984b0aae5dcb78636b705d.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/119c2a45c200454cb72e4fa160ae7c6f.jpg"], 2, 0, 2020-11-29 18:57:15.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/bbe08735bbc34b5a9eaf5e9890206ff7.zip, .zip, 188B, 1, 1, -]
361840 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026, rs-50658} closed
361840 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20026} clearParameters. 
361840 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361841 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361841 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} Parameters : [1]
361841 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} Types : [INTEGER]
361842 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} executed. 0.7097 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
361842 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50659} open
361842 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50659} Header: [id, open_id, name, sex, img, info, status, role, register_time]
361842 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50659} Result: [1, 1111, 管理员, 1, https://s1.ax1x.com/2020/08/30/dqJ6wd.jpg, 一只小张三, 1, 1, 2020-11-02 20:50:28.0]
361842 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50659} closed
361842 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} clearParameters. 
361842 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361843 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361843 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} Parameters : [1]
361843 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} Types : [INTEGER]
361843 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} executed. 0.607 millis. select
          id, name, count  
        from kind
         WHERE id = ?
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50660} open
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50660} Header: [id, name, count]
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50660} Result: [1, 图片, 3]
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50660} closed
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} clearParameters. 
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} Parameters : [35]
361844 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} Types : [INTEGER]
361845 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} executed. 0.6322 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
361845 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50661} open
361845 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50661} Header: [ROUND(avg(stars))]
361845 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50661} Result: [null]
361845 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50661} closed
361845 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} clearParameters. 
361845 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361846 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361846 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} Parameters : [35]
361846 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} Types : [INTEGER]
361847 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} executed. 0.8204 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
361847 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50662} open
361847 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50662} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
361847 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50662} closed
361847 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} clearParameters. 
361847 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361847 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361848 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027} Parameters : [1, 35]
361848 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027} Types : [INTEGER, INTEGER]
361848 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027} executed. 0.6841 millis. select
            id, user_id, material_id  
        from favorite
         where  user_id = ?
        
        
                and material_id = ?
361848 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027, rs-50663} open
361848 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027, rs-50663} Header: [id, user_id, material_id]
361848 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027, rs-50663} Result: [23, 1, 35]
361849 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027, rs-50663} closed
361849 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20027} clearParameters. 
361849 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361849 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361849 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20028} Parameters : [35]
361849 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20028} Types : [INTEGER]
361851 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20028} executed. 1.1691 millis. select   id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
        where material_id = ? and reply_id = 0 order by comment_time desc
361851 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20028, rs-50664} open
361851 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20028, rs-50664} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
361851 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20028, rs-50664} closed
361851 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20028} clearParameters. 
361852 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361856 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361857 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} Parameters : [2]
361857 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} Types : [INTEGER]
361857 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} executed. 0.7128 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
361857 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50665} open
361857 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50665} Header: [id, open_id, name, sex, img, info, status, role, register_time]
361857 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50665} Result: [2, 2222, 杰瑞, 0, https://s1.ax1x.com/2020/08/30/dqJhSf.jpg, 一只小耗子, 1, 0, 2020-11-18 15:56:06.0]
361858 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50665} closed
361858 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} clearParameters. 
361858 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361858 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361858 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} Parameters : [1]
361858 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} Types : [INTEGER]
361859 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} executed. 0.77 millis. select
          id, name, count  
        from kind
         WHERE id = ?
361859 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50666} open
361859 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50666} Header: [id, name, count]
361859 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50666} Result: [1, 图片, 3]
361860 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50666} closed
361860 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} clearParameters. 
361860 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361860 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361860 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} Parameters : [17]
361860 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} Types : [INTEGER]
361861 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} executed. 0.884 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
361861 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50667} open
361861 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50667} Header: [ROUND(avg(stars))]
361861 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50667} Result: [5]
361861 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50667} closed
361862 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} clearParameters. 
361862 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361862 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361862 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} Parameters : [17]
361862 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} Types : [INTEGER]
361863 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} executed. 0.9925 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
361863 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50668} open
361863 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50668} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
361864 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50668} Result: [10, 2, 17, @@@@, 5, 0, 2020-11-29 19:02:18.0, 0]
361864 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50668} closed
361864 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} clearParameters. 
361864 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361865 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361865 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} Parameters : [2]
361865 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} Types : [INTEGER]
361865 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} executed. 0.7497 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
361866 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50669} open
361866 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50669} Header: [id, open_id, name, sex, img, info, status, role, register_time]
361866 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50669} Result: [2, 2222, 杰瑞, 0, https://s1.ax1x.com/2020/08/30/dqJhSf.jpg, 一只小耗子, 1, 0, 2020-11-18 15:56:06.0]
361866 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007, rs-50669} closed
361866 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20007} clearParameters. 
361866 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361866 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361867 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} Parameters : [1]
361867 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} Types : [INTEGER]
361867 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} executed. 0.6986 millis. select
          id, name, count  
        from kind
         WHERE id = ?
361867 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50670} open
361867 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50670} Header: [id, name, count]
361867 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50670} Result: [1, 图片, 3]
361868 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008, rs-50670} closed
361868 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20008} clearParameters. 
361868 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361868 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361868 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} Parameters : [18]
361868 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} Types : [INTEGER]
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} executed. 2.4382 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50671} open
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50671} Header: [ROUND(avg(stars))]
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50671} Result: [5]
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009, rs-50671} closed
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20009} clearParameters. 
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
361871 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-connect
361872 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} Parameters : [18]
361872 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} Types : [INTEGER]
361872 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} executed. 0.8202 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
361873 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50672} open
361873 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50672} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
361873 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50672} Result: [4, 2, 18, Nice, 5, 0, 2020-11-29 19:01:13.0, 0]
361873 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010, rs-50672} closed
361873 DEBUG [2020-11-30 18:05:18]  {conn-10005, pstmt-20010} clearParameters. 
361873 DEBUG [2020-11-30 18:05:18]  {conn-10005} pool-recycle
363048 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363049 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000} Parameters : []
363049 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000} Types : []
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000} executed. 4.2448 millis. select
            id, name, count  
        from kind
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} open
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} Header: [id, name, count]
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} Result: [1, 图片, 3]
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} Result: [3, 音频, 2]
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} Result: [4, 字体, 3]
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} Result: [5, WorldPress主题, 1]
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} Result: [6, 前端页面, 3]
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} Result: [13, PPT模板, 4]
363053 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000, rs-50673} closed
363054 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20000} clearParameters. 
363054 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363054 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363054 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001} Parameters : []
363054 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001} Types : []
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001} executed. 0.5927 millis. select
            id, name, target_url, type  
        from link
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001, rs-50674} open
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001, rs-50674} Header: [id, name, target_url, type]
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001, rs-50674} Result: [5, 百度, http://www.baidu.com, 2]
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001, rs-50674} Result: [6, 字体素材, http://127.0.0.1:8082/su-share/materials?kId=4, 1]
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001, rs-50674} Result: [7, WordPress精选主题, http://127.0.0.1:8082/su-share/materials?kId=5, 1]
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001, rs-50674} closed
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20001} clearParameters. 
363055 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363057 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363058 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016} Parameters : [1]
363058 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016} Types : [INTEGER]
363060 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016} executed. 2.2442 millis. SELECT count(0) FROM material LEFT JOIN favorite ON favorite.material_id = material.id WHERE favorite.user_id = ? AND material.status = 1 AND material.is_checked = 1
363060 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016, rs-50675} open
363060 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016, rs-50675} Header: [count(0)]
363060 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016, rs-50675} Result: [1]
363060 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016, rs-50675} closed
363060 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20016} clearParameters. 
363061 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017} Parameters : [1, 5]
363061 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017} Types : [INTEGER, INTEGER]
363061 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017} executed. 0.7342 millis. select * from material
        left join favorite on favorite.material_id = material.id
        where favorite.user_id = ? and material.status = 1 and material.is_checked = 1
        order by favorite.id desc LIMIT ? 
363061 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017, rs-50676} open
363061 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017, rs-50676} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info, id, user_id, material_id]
363061 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017, rs-50676} Result: [35, 1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 8, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -, 23, 1, 35]
363062 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017, rs-50676} closed
363062 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20017} clearParameters. 
363062 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363062 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363064 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20018} Parameters : [1, 0]
363064 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20018} Types : [INTEGER, INTEGER]
363064 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20018} executed. 0.8837 millis. select
            id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         where  status = ?
        
        
                and is_checked = ? 
        order by publish_time desc
363064 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20018, rs-50677} open
363065 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20018, rs-50677} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
363065 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20018, rs-50677} closed
363065 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20018} clearParameters. 
363065 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363065 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363065 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20019} Parameters : [1, 0]
363066 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20019} Types : [INTEGER, INTEGER]
363069 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20019} executed. 3.0589 millis. select
            id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time  
        from message
         where  receive_user_id = ?
        
        
        
        
        
        
                and is_read = ?
363069 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20019, rs-50678} open
363069 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20019, rs-50678} Header: [id, receive_user_id, sent_user_id, sent_user_img, content, material_id, is_read, message_time]
363069 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20019, rs-50678} closed
363069 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20019} clearParameters. 
363069 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363071 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363071 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030} created. SELECT count(0) FROM material WHERE status = ? AND is_checked = ?
363071 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030} Parameters : [1, 1]
363071 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030} Types : [INTEGER, INTEGER]
363072 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030} executed. 0.7018 millis. SELECT count(0) FROM material WHERE status = ? AND is_checked = ?
363072 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030, rs-50679} open
363072 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030, rs-50679} Header: [count(0)]
363072 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030, rs-50679} Result: [16]
363075 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030, rs-50679} closed
363075 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20030} clearParameters. 
363076 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20020} closed
363076 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031} created. select
            id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         where  status = ?
        
        
                and is_checked = ? 
        order by publish_time desc LIMIT ? 
363076 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031} Parameters : [1, 1, 12]
363076 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031} Types : [INTEGER, INTEGER, INTEGER]
363077 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031} executed. 1.0547 millis. select
            id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info  
        from material
         where  status = ?
        
        
                and is_checked = ? 
        order by publish_time desc LIMIT ? 
363077 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} open
363077 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Header: [id, user_id, name, kind_id, info, img, imgs, read_count, download_count, publish_time, file_path, extension, size, status, is_checked, checked_info]
363078 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [35, 1, 杨洋, 1, 杨洋照片~, https://gitee.com/huang-xiangting/su-share/raw/master/1/fd653415639f4f7fbecdc199f4af2be4.jpg, ["https://gitee.com/huang-xiangting/su-share/raw/master/1/757c96f869ff4a038230f1b8c4c5b8e1.jpg"], 8, 2, 2020-11-30 09:19:22.0, https://my-su-share.oss-cn-beijing.aliyuncs.com/1/3ed0d7f460cd4c6a969d507a672daa02.jpg, .jpg, 15.8KB, 1, 1, -]
363078 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [26, 2, 植物叶子昆虫线条PPT小图标, 13, 植物叶子昆虫线条PPT小图标。一组线性线条植物叶子小昆虫小图标，PPT绘制，颜色大小可编辑, https://gitee.com/cn_moti/su-share/raw/master/2/196ad9b10e4d4d48adcc606617010976.jpg, [], 0, 0, 2020-11-29 19:37:37.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/125b9c69931c4a48b48ab160d5f6ddc8.zip, .zip, 188B, 1, 1, -]
363078 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [25, 2, 时尚画册杂志欧美风PPT模板, 13, 时尚画册杂志欧美风PPT模板。一套时尚欧美风幻灯片模板，多种图文排版页面，适合杂志画册幻灯片设计。, https://gitee.com/cn_moti/su-share/raw/master/2/3cab494ab6e649fca5d89b28ce4b3105.jpg, ["https://gitee.com/cn_moti/su-share/raw/master/2/9f91c84baa5844a89cf4e23a510223e2.jpg"], 18, 1, 2020-11-29 19:36:52.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/2e6624d1dc6c4947887d55aa264a29ef.zip, .zip, 188B, 1, 1, -]
363079 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [24, 3, 全宽布局绿色果蔬食品, 6, 好看, https://gitee.com/cn_moti/su-share/raw/master/3/f107324731b6494bab6ce2ed430f69d9.jpg, [], 15, 0, 2020-11-29 19:15:16.0, https://su-share.oss-cn-beijing.aliyuncs.com/3/c2a7cdaf2d9743a9bb0455b69a2f8089.zip, .zip, 188B, 1, 1, -]
363079 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [23, 3, 简约版个人博客主题, 5, 舒服！, https://gitee.com/cn_moti/su-share/raw/master/3/21dc87caf4ed4b43ba9148281c210865.jpg, [], 9, 0, 2020-11-29 19:13:21.0, https://su-share.oss-cn-beijing.aliyuncs.com/3/c4d7139c2bab4245b9b29550141771d9.zip, .zip, 188B, 1, 1, -]
363079 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [22, 3, 毛不易-像我这样的人, 3, 啦啦啦, https://gitee.com/cn_moti/su-share/raw/master/3/4897821f525d4821a8e06af2ff7d6a50.jpg, [], 10, 0, 2020-11-29 19:10:23.0, https://su-share.oss-cn-beijing.aliyuncs.com/3/46a92e54298d4fd4bb105d4eeead495d.zip, .zip, 188B, 1, 1, -]
363079 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [21, 3, 毛不易-想你想你, 3, 超好听！, https://gitee.com/cn_moti/su-share/raw/master/3/0bdfe1cc7b0148e38de35c484198f3f3.jpg, [], 11, 0, 2020-11-29 19:09:27.0, https://su-share.oss-cn-beijing.aliyuncs.com/3/9cd4b91244144085bc512c7ac7227842.zip, .zip, 188B, 1, 1, -]
363079 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [20, 2, 抽奖插件 仿京东大转盘抽京豆, 6, 一个基于原生 javript vue2 vue3 的大转盘抽奖插件, https://gitee.com/cn_moti/su-share/raw/master/2/c41cc8b0c988419599ef264c9d2c9c8d.jpg, [], 11, 1, 2020-11-29 18:59:37.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/179eb1733a9c4b6b911968848821e080.zip, .zip, 188B, 1, 1, -]
363079 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [19, 2, bootstrap响应式鞋子商城网页模板, 6, jQuery bootstrap响应式鞋子商城网页模板，多种风格，页面功能齐全, https://gitee.com/cn_moti/su-share/raw/master/2/08494ccfe40d45c6af92701fa9f49a39.jpg, [], 4, 0, 2020-11-29 18:58:43.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/16a10468d5974cbfbaeace4f5b34ccea.zip, .zip, 188B, 1, 1, -]
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [18, 2, 26张高清沙漠背景图片, 1, 高清沙漠PPT背景图片，共26张，JPG格式，高清大图，漂亮的沙漠风景幻灯片背景图片。 , https://gitee.com/cn_moti/su-share/raw/master/2/a002baff05494e408799962e095b5717.jpg, ["https://gitee.com/cn_moti/su-share/raw/master/2/3470504d63984b0aae5dcb78636b705d.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/119c2a45c200454cb72e4fa160ae7c6f.jpg"], 2, 0, 2020-11-29 18:57:15.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/bbe08735bbc34b5a9eaf5e9890206ff7.zip, .zip, 188B, 1, 1, -]
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [17, 2, 城市俯视鸟瞰背景图片, 1, 城市俯视鸟瞰PPT背景图片。一组城市俯瞰图片，jpg格式高清大图，大气磅礴，适合商务类PPT背景图片使用。, https://gitee.com/cn_moti/su-share/raw/master/2/72d8adf428c04734bf3ab4716f28fa02.jpg, ["https://gitee.com/cn_moti/su-share/raw/master/2/6c62b29b0a9c4c6f9ea203efe275ab92.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/e8ce1e01fe5f4366aad7a585d4f18f4f.jpg","https://gitee.com/cn_moti/su-share/raw/master/2/7a89ddf9fc484b159ce7bd0f5624cdc2.jpg"], 2, 0, 2020-11-29 18:56:08.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/8f695c0ef4aa4ff18ccf09a214e4b4a2.zip, .zip, 188B, 1, 1, -]
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} Result: [16, 2, 字魂7号-温暖童稚体字体, 4, 字魂7号-温暖童稚体字体下载。上一个：熊孩子体 ，下一个：没有了 。安装方法：打开压缩包，双击字体文件，点击“安装”按钮即可。仅供学习使用，商用请联系作者。, https://gitee.com/cn_moti/su-share/raw/master/2/75df4f2e44494d6d916050d4b832d989.jpg, [], 3, 0, 2020-11-29 18:53:05.0, https://su-share.oss-cn-beijing.aliyuncs.com/2/1230de4175ba4ec28964f1a254359299.zip, .zip, 188B, 1, 1, -]
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031, rs-50680} closed
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20031} clearParameters. 
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20021} closed
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363080 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363081 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032} created. select
          id, content, notice_time  
        from notice
         WHERE id = ?
363081 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032} Parameters : [1]
363081 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032} Types : [INTEGER]
363082 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032} executed. 1.0599 millis. select
          id, content, notice_time  
        from notice
         WHERE id = ?
363082 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032, rs-50681} open
363082 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032, rs-50681} Header: [id, content, notice_time]
363082 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032, rs-50681} Result: [1, 本站致力于打造一个友好免费的素材分享平台。快来注册分享你的宝库吧~      本站承诺所有素材都可免费下载！
<br>, 2020-11-30 09:09:13.0]
363082 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032, rs-50681} closed
363083 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20032} clearParameters. 
363083 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20022} closed
363083 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363083 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363084 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Parameters : [1]
363084 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Types : [INTEGER]
363084 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} executed. 0.8651 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50682} open
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50682} Header: [id, open_id, name, sex, img, info, status, role, register_time]
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50682} Result: [1, 1111, 管理员, 1, https://s1.ax1x.com/2020/08/30/dqJ6wd.jpg, 一只小张三, 1, 1, 2020-11-02 20:50:28.0]
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50682} closed
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} clearParameters. 
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Parameters : [1]
363085 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Types : [INTEGER]
363087 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} executed. 1.4133 millis. select
          id, name, count  
        from kind
         WHERE id = ?
363087 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50683} open
363087 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50683} Header: [id, name, count]
363087 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50683} Result: [1, 图片, 3]
363087 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50683} closed
363088 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} clearParameters. 
363095 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363096 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363097 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Parameters : [35]
363097 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Types : [INTEGER]
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} executed. 1.0448 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50684} open
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50684} Header: [ROUND(avg(stars))]
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50684} Result: [null]
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50684} closed
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} clearParameters. 
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363098 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363099 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Parameters : [35]
363099 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Types : [INTEGER]
363099 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} executed. 0.9042 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
363100 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50685} open
363100 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50685} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
363100 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50685} closed
363100 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} clearParameters. 
363100 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363101 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363102 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Parameters : [2]
363102 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Types : [INTEGER]
363103 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} executed. 1.3732 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
363103 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50686} open
363103 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50686} Header: [id, open_id, name, sex, img, info, status, role, register_time]
363104 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50686} Result: [2, 2222, 杰瑞, 0, https://s1.ax1x.com/2020/08/30/dqJhSf.jpg, 一只小耗子, 1, 0, 2020-11-18 15:56:06.0]
363105 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50686} closed
363105 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} clearParameters. 
363105 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363105 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363105 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Parameters : [13]
363105 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Types : [INTEGER]
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} executed. 0.666 millis. select
          id, name, count  
        from kind
         WHERE id = ?
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50687} open
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50687} Header: [id, name, count]
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50687} Result: [13, PPT模板, 4]
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50687} closed
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} clearParameters. 
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363106 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363107 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Parameters : [26]
363107 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Types : [INTEGER]
363107 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} executed. 0.608 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
363107 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50688} open
363107 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50688} Header: [ROUND(avg(stars))]
363107 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50688} Result: [null]
363107 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50688} closed
363108 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} clearParameters. 
363108 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363108 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363108 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Parameters : [26]
363108 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Types : [INTEGER]
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} executed. 0.6487 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50689} open
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50689} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50689} closed
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} clearParameters. 
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Parameters : [2]
363109 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Types : [INTEGER]
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} executed. 0.4786 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50690} open
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50690} Header: [id, open_id, name, sex, img, info, status, role, register_time]
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50690} Result: [2, 2222, 杰瑞, 0, https://s1.ax1x.com/2020/08/30/dqJhSf.jpg, 一只小耗子, 1, 0, 2020-11-18 15:56:06.0]
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50690} closed
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} clearParameters. 
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Parameters : [13]
363110 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Types : [INTEGER]
363111 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} executed. 0.7315 millis. select
          id, name, count  
        from kind
         WHERE id = ?
363111 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50691} open
363111 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50691} Header: [id, name, count]
363111 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50691} Result: [13, PPT模板, 4]
363111 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50691} closed
363111 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} clearParameters. 
363112 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363112 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363112 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Parameters : [25]
363112 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Types : [INTEGER]
363113 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} executed. 0.624 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
363113 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50692} open
363113 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50692} Header: [ROUND(avg(stars))]
363113 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50692} Result: [4]
363113 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50692} closed
363113 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} clearParameters. 
363113 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363114 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363114 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Parameters : [25]
363114 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Types : [INTEGER]
363116 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} executed. 2.583 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
363116 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50693} open
363116 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50693} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
363117 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50693} Result: [26, 3, 25, 好好好, 4, 0, 2020-11-30 09:04:12.0, 0]
363117 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50693} closed
363117 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} clearParameters. 
363117 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363117 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363117 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Parameters : [3]
363117 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} Types : [INTEGER]
363119 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} executed. 1.8225 millis. select
          id, open_id, name, sex, img, info, status, role, register_time  
        from user
         WHERE id = ?
363120 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50694} open
363120 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50694} Header: [id, open_id, name, sex, img, info, status, role, register_time]
363120 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50694} Result: [3, 3333, 露丝, 0, https://dss1.bdstatic.com/70cFuXSh_Q1YnxGkpoWK1HF6hhy/it/u=2135068181,2006355012&fm=111&gp=0.jpg, 哦~, 1, 0, 2020-11-29 19:03:18.0]
363120 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007, rs-50694} closed
363120 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20007} clearParameters. 
363121 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363122 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363122 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Parameters : [6]
363122 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} Types : [INTEGER]
363123 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} executed. 0.8353 millis. select
          id, name, count  
        from kind
         WHERE id = ?
363123 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50695} open
363123 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50695} Header: [id, name, count]
363123 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50695} Result: [6, 前端页面, 3]
363123 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008, rs-50695} closed
363123 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20008} clearParameters. 
363124 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363124 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363124 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Parameters : [24]
363124 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} Types : [INTEGER]
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} executed. 0.6926 millis. SELECT ROUND(avg(stars)) from `comment` WHERE reply_id = 0 and material_id = ?
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50696} open
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50696} Header: [ROUND(avg(stars))]
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50696} Result: [null]
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009, rs-50696} closed
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20009} clearParameters. 
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-connect
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Parameters : [24]
363125 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} Types : [INTEGER]
363126 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} executed. 0.6046 millis. select
            id, user_id, material_id, content, stars, reply_id, comment_time, is_first  
        from comment
         where  material_id = ?
363126 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50697} open
363126 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50697} Header: [id, user_id, material_id, content, stars, reply_id, comment_time, is_first]
363126 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010, rs-50697} closed
363126 DEBUG [2020-11-30 18:05:19]  {conn-10005, pstmt-20010} clearParameters. 
363126 DEBUG [2020-11-30 18:05:19]  {conn-10005} pool-recycle
